﻿/********************************************************************************
* Author:	Christos Polydorou	(xristos.polydoroy@gmail.com)					*
* Author:	Aris Michail		(aris.michail@gmail.com)						*
* Date:		22/9/2011															*
********************************************************************************/

CREATE PROCEDURE [dbo].[userRegister]
        @username nvarchar(50),
		@password nvarchar(50),
		@email nvarchar(50),
		@fname nvarchar(50),
		@lname nvarchar(50)
AS
		INSERT INTO Users
		VALUES(@username,@password,@email,'std','0',DATEADD(MINUTE,-10,GETDATE()),'0',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,@fname,@lname)
		RETURN 0 